home *** CD-ROM | disk | FTP | other *** search
/ Agent Central Host Computer / Agent - Central Host Computer.iso / _SETUP.1 / batchtotals.sql < prev    next >
Text File  |  2000-05-12  |  703b  |  21 lines
  1. /* RCSVER $Id: batchtotals.sql,v 1.2 1999-03-24 09:13:53-06 evan CURRENT $ */
  2. /* *************************************************************************
  3. *        Copyright (C) 1998, Agent Systems, Inc. All Rights Reserved.
  4. *
  5. * Name:        cashboxcount
  6. * Date:        1/10/1999
  7. * memo:        Evan M. Ghormley    
  8. * Description:    Create the cashboxcount table. 
  9. * Changes:
  10. ************************************************************************* */
  11. CREATE TABLE batchtotals
  12. (
  13.       batch_total_seq_num    NUMBER(38) PRIMARY KEY,
  14.       acctday_total_seq_num       NUMBER(38),    
  15.       count_date        DATE,
  16.     coin_total            NUMBER(20,2),
  17.     bill_total              NUMBER(20,2),
  18.     grand_total            NUMBER(20,2)
  19. );
  20.  
  21.